/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2012                    */
/* Created on:     2017/8/19 8:35:59                            */
/*==============================================================*/


if exists (select 1
            from  sysobjects
           where  id = object_id('tbl_Rank')
            and   type = 'U')
   drop table tbl_Rank
go

/*==============================================================*/
/* Table: tbl_Rank                                              */
/*==============================================================*/
create table tbl_Rank (
   Code                 int                  not null,
   Name                 varchar(50)          null,
   Shorthand            varchar(50)          null,
   CurDate              varchar(20)          null,
   NetAssetValue        varchar(20)          null,
   AccumulatedNet       varchar(20)          null,
   DailyGrowth          varchar(20)          null,
   LastWeek             varchar(20)          null,
   LastMonth            varchar(20)          null,
   Last3Month           varchar(20)          null,
   Last6Month           varchar(20)          null,
   LastYear             varchar(20)          null,
   Last2Year            varchar(20)          null,
   Last3Year            varchar(20)          null,
   ThisYear             varchar(20)          null,
   SinceBuilt           varchar(20)          null,
   Custom               varchar(20)          null,
   BuiltDate            varchar(20)          null,
   Poundage             varchar(20)          null,
   PoundageCount        varchar(20)          null,
   constraint PK_TBL_RANK primary key (Code)
)
go

